CSV import agent

Notes/Domino 8 Forum

Subject:

CSV import agent

I suspect that the content of one of the fields you get in the Excel spreadsheet is a numeric value, for example 3210034. When you import it, it does not matter that the field in the Notes form is specified as text, the importer will store it in the Notes document as a number (which would explain the issue you are having).
That is why I asked what the document properties infobox show as data type for the field.

Your import process is more complicated than it has to be. Write a simple CSV importer in Lotusscript, then you can perform a doc.ComputeWithForm to get the data types correct, and you can also perform other checks on the imported values if you like.

If you write a CSV import agent, you only have to save the Excel document as .CSV, and you are done...

I even wrote a CSV import class a while back and posted the code on my blog.
http://blog.texasswede.com/import-csv-from-excel-into-notes-documents/

Feedback response number WEBB8ZF7GB created by ~Dan Kikiterobu on 10/26/2012